CREATE TABLE CRST_FA_LOCATIONS
(
LOCATION_ID             NUMBER (15), 
SEGMENT1                VARCHAR (30), 
SEGMENT2                VARCHAR (30) ,
SEGMENT3                VARCHAR (30) ,
SEGMENT4                VARCHAR (30) ,
SEGMENT5                VARCHAR (30) ,
SEGMENT6                VARCHAR (30) ,
SEGMENT7                VARCHAR (30) ,
SUMMARY_FLAG            VARCHAR (1) ,
ENABLED_FLAG            VARCHAR (1) ,
START_DATE_ACTIVE       DATE ,
END_DATE_ACTIVE         DATE ,
LAST_UPDATE_DATE        DATE ,
LAST_UPDATED_BY         NUMBER (15) ,
LAST_UPDATE_LOGIN       NUMBER (15) ,
ATTRIBUTE1              VARCHAR (150), 
ATTRIBUTE2              VARCHAR (150) ,
ATTRIBUTE3              VARCHAR (150) ,
ATTRIBUTE4              VARCHAR (150) ,
ATTRIBUTE5              VARCHAR (150) ,
ATTRIBUTE6              VARCHAR (150) ,
ATTRIBUTE7              VARCHAR (150) ,
ATTRIBUTE8              VARCHAR (150) ,
ATTRIBUTE9              VARCHAR (150) ,
ATTRIBUTE10             VARCHAR (150) ,
ATTRIBUTE11             VARCHAR (150) ,
ATTRIBUTE12             VARCHAR (150) ,
ATTRIBUTE13             VARCHAR (150) ,
ATTRIBUTE14             VARCHAR (150) ,
ATTRIBUTE15             VARCHAR (150) ,
ATTRIBUTE_CATEGORY_CODE VARCHAR (30) ,
LOCATION_ID_N			NUMBER (15)
);
